SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
and (bedrooms >='4') and (bedrooms >='4')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Charming 4 bedroom, 1 bathroom Cape located on a dead end road close to the walking trail to Lebanon High School, and just a short walk to the Lebanon Green, Lebanon Opera House, restaurants and the Post Office. Extensively renovated in 2019 the home is move-in ready with updated kitchen, bathroom, paint and flooring, 8 year old heating system, and stabilization foundation work in full walk-out basement with lifetime warranty. One car detached garage with storage space below. The house is currently rented until 5/1/2025. Showings by appointment.
Description:161 BANK STREET EXTENSION- This recently renovated 4 bedroom, 2 bath cape is ideally located with close proximity to the Lebanon Green, Middle and High Schools, Dartmouth Hitchcock, Hypertherm and the Rail Trail. The first floor features a newly renovated kitchen and updated first floor bathroom, a comfortable dining and living space, the primary bedroom and a second bedroom which is currently being used as a home office. Upstairs has newly installed flooring, a 3/4 bath and two nice sized bedrooms. A bright three-season porch opens into a recently landscaped backyard with new patio, while the full basement provides ample storage space and potential for additional living area. Additional updates include a new roof, and new front and back doors. A wonderful home in a fantastic location!
Description:Fantastic Lebanon Location! This charming, well-maintained, and updated 4-bedroom (3 on the tax card), 1.75-bath property is just a short walk from stores, restaurants, and the Lebanon Opera House. Reach Dartmouth College and downtown Hanover or the Dartmouth Hitchcock Medical Center in about 10 minutes. The first floor features hardwood floors throughout with radiant heating, a kitchen that includes a large breakfast bar and a 3-season porch directly off it, a bonus room (office, dining nook, etc.), a full bath, and a separate laundry room. The front of the home consists of open living and dining areas with lovely, freshly painted trim and crown moldings. Upstairs, you'll find 4 bedrooms and a 3/4 bath, all with new lighting, gleaming floors, and fresh paint. Further up is a walk-up space for storage or a cozy getaway. The basement houses your utilities with plenty of room for a workbench or storage. Outside, you will find space for gardens, complete with irrigation, and a newly roofed garage for your toys or vehicle. Come and see for yourself!
Description:This delightful residence is nestled in the picturesque village of Plainfield, NH. A truly inviting property that offers a harmonious blend of classic charm and modern comfort. As you approach the home, you'll be greeted by its timeless design and beautifully maintained lawn and gardens. The open-concept kitchen to dining to living room is perfect for both daily living and entertaining others. The well-appointed kitchen is a chef's dream, complete with newer fridge, a dishwasher, and microwave, generous granite counter space, and plenty of cabinetry for storage. Many other features including: Central AC, mudroom, second floor laundry, updated fixtures, newly painted throughout, and professional interior designer crafted rooms. Located just a short drive from local amenities and scenic attractions, this home combines the best of both worlds—peaceful village living with convenient access to everyday necessities. Only 15 miles (25mins) to DHMC! Don’t miss your chance to own this exceptional property. Agent related to sellers.
Description:Motivated Seller! Offers Deadline Sunday 6pm. This well maintained Cape home is nestled on a beautiful lot in a highly sought-after neighborhood in the heart of West Lebanon. As you step inside, you're greeted by a warm and inviting atmosphere that extends throughout every room. The first floor features an open-concept kitchen and dining area, seamlessly flowing into a bright and airy family/living room, along with a convenient half-bath. Upstairs, you'll find four bedrooms and a full bath, providing ample space for family, guests, or a home office. Beautifully maintained hardwood floors enhance the home's charm and character. On warm summer days, relax in the enclosed porch or step outside to enjoy the beautifully landscaped backyard. The spacious mudroom, located off the back entrance, leads to both the two-car garage and the backyard oasis. Whether you have a green thumb, enjoy outdoor activities, or simply want to unwind on the patio while listening to the gentle sounds of the man-made fountain, this space offers endless possibilities. The large basement provides plenty of storage and potential for future expansion—transform it into a home gym, private workshop, or additional finished living space. Situated in a prime location, this home is close to the Little League Field, shopping centers, and offers quick access to Hanover and surrounding amenities. A rare find, this move-in-ready home is perfect for full-time living.
Description:Classic West Lebanon new englander in great location! This house has SO much to offer! Great spaces - including eat-in kitchen, playroom with slider to the deck and renovated 3/4 bathroom, den and formal living room combination. Upstairs you will find 3-4 bedrooms and a renovated full bathroom including a gorgeous primary bedroom with new wood floors and walk in closet. Attic is finished and would be great for a playroom, office or guest bedroom. House has had lots of updates - new roof, renovated laundry room, newer appliances, refinished wood floors, newly paved driveway - and more! Showings start with Open House Saturday, April 5th 10:00-12:30 and Sunday, April 6th 1:00-3:30.
Description:HUGE PRICE REDUCTION! Abundant Sunshine fills this 2017 Colonial situated on 1.75 acres offering 4 bedrooms, open concept layout, sunshine galore makes your living space bright and inviting, gleaming hardwood floors, convenient 1st floor living w/laundry, 3/4 bath & bedroom, 2nd floor offers 3 bedrooms, a full bath and great closet space everywhere. The attached oversized 2 car garage flows seamlessly into the heated entry room with abundant storage affording ease with the comings and goings that your busy day entails. The lower level is impressive with it's high ceilings, easy expansion possibilities, Buderus propane boiler and spray foamed for add'l heat efficiency. The detached barn screams quintessential New England and offers two levels for game room, "toy" storage, third car garage or hey, why not rent the bay for seasonal storage and extra income. All this and a commuters dream! A hop & a skip to Mascoma Lake and only 1 mile to I-89 for easy access to Dartmouth Hitchcock Hospital and all Upper Valley Amenities.
Description:Step into history at The Treetops, an extraordinary 4-bedroom, 2-bath home that was once part of the original Saint-Gaudens estate. This stunning property carries the spirit of the famed Cornish Art Colony, where master sculptor Augustus Saint-Gaudens and his creative circle found inspiration in the rolling hills of New Hampshire. Perched on a scenic private lot, this home offers a tranquil retreat surrounded by nature. A gentle stream winds through the property, adding to the peaceful ambiance, while garden spaces provide the perfect setting for cultivating beauty—just as artists once did in this very landscape. From the sun-drenched rooms to the charming historic details, The Treetops is a timeless escape that seamlessly blends past and present. Located just minutes from the Upper Valley, with easy access to both sides of the Connecticut River, this home offers the perfect balance of seclusion and convenience—close to Dartmouth College, world-class healthcare, vibrant arts, and year-round outdoor recreation. This is more than just a home; it's a living piece of history in one of New Hampshire’s most picturesque and storied communities. Opportunities like this are rare—don’t miss your chance to own a legacy!
Description:Embrace the vibrant heart of Hanover with this newly renovated home on Lebanon St, offering the ultimate in downtown living within walking distance to the CoOp and the bus line. Perfectly situated between Dartmouth College and DHMC, this property boasts a walk-out basement providing extra storage. The first floor showcases a contemporary touch with brand new hardwood floors, a renovated kitchen and 3bedrooms, one with a 3/4 bath. Upstairs, the second floor introduces an in-law suite with hardwood floors, new kitchen, 2 bedrooms and a bath with private washer and dryer all with a private exterior entrance. Take advantage of the prime location and the properties surrounding walking trails and Mink Brook. Welcome to Hanover!
Description:Discover a rare gem in the heart of Lebanon—this expansive single level 4-bedroom, 4-bathroom home is nestled on 43 picturesque acres. Enjoy stunning westerly views, ample living space, and the perfect blend of privacy and convenience. This unique property offers the tranquility of country living with all the benefits of being close to town. With several acres of open pasture land and a barn/stable, the property would be well suited for horses or other grazing animals. The 10 KW solar array reduces current power demands with room for future expansion. Imagine snowshoeing, and cross-country skiing on your own land in the winter while enjoying the pollinator flowers and organic vegetable gardens by the half basketball court. The downstairs includes a library, bar, and a large space to create what you want. In addition, the property benefits from easy access to downtown Lebanon, Dartmouth College, Dartmouth-Hitchcock, I89 and I91, Lebanon Airport, and the Dartmouth Coach, which goes to New York or Boston. Don’t miss out on this exceptional opportunity located at the end of a dead-end road! Home is being sold as is. The property does need work to make it special again.